{ "cells": [ { "cell_type": "markdown", "id": "970ad54f-5c94-4032-aab3-14909923f016", "metadata": {}, "source": [ "![title](https://raw.githubusercontent.com/messari/messari-python-api-private/main/examples/notebooks/images/deepdao_messari_python.PNG?token=ADKDZDHLWXHNU3P5FHWDBMDBXJJSA)" ] }, { "cell_type": "markdown", "id": "likely-radio", "metadata": {}, "source": [ "# DeepDAO Python API Tutorial " ] }, { "cell_type": "markdown", "id": "d22e8023", "metadata": {}, "source": [ "This tutorial aims to be a quick guide to get you started using the DeepDAO API integrated into messari's python library." ] }, { "cell_type": "code", "execution_count": 3, "id": "593e4795", "metadata": {}, "outputs": [], "source": [ "from messari.deepdao import DeepDAO\n", "dd = DeepDAO()" ] }, { "cell_type": "markdown", "id": "813f1412", "metadata": {}, "source": [ "## API Structure\n", "The Deep DAO Python client contains a number of functions that wrap some of Deep DAO's API endpoints. These include:\n", "\n", "Helpers\n", "* get_dao_list\n", "* get_member_list\n", "\n", "Overview\n", "* get_organizations\n", "* get_summary\n", "* get_rankings\n", "* get_tokens\n", "\n", "DAOs\n", "* get_dao_info\n", "* get_dao_indices\n", "* get_dao_proposals\n", "* get_dao_members\n", "* get_dao_voter_coalitions\n", "* get_dao_financials\n", "\n", "Members\n", "* get_top_members\n", "* get_member_info\n", "* get_member_proposals\n", "* get_member_votes\n", "\n", "Below are a few examples to showcase the functionality and types of data each function generates." ] }, { "cell_type": "markdown", "id": "ecd6b9b7", "metadata": {}, "source": [ "## Helpers" ] }, { "cell_type": "markdown", "id": "bac27ec5", "metadata": {}, "source": [ "These set functions return lists which can be used to find Deep DAO supported DAOs as well as DAO Members" ] }, { "cell_type": "markdown", "id": "a40e89fa", "metadata": {}, "source": [ "### Get dao list" ] }, { "cell_type": "markdown", "id": "3b1e3b3d", "metadata": {}, "source": [ "The function returns a list of all the DAOs tracked by DeepDAO" ] }, { "cell_type": "code", "execution_count": 4, "id": "de221c03", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['DimensionLab', 'JuiceboxDAO', 'Constitution', 'ApocalypseDAO', 'BarnBridge']" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dao_list = dd.get_dao_list()\n", "dao_list[:5]" ] }, { "cell_type": "markdown", "id": "54811e08", "metadata": {}, "source": [ "### Get member list" ] }, { "cell_type": "markdown", "id": "fd78d2e9", "metadata": {}, "source": [ "The function returns a list of all the DAO Members tracked by DeepDAO" ] }, { "cell_type": "code", "execution_count": 5, "id": "605e8a12", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['Ven Gist', 'scottrepreneur', \"Peter 'pet3rpan'\", 'Deke', 'Coopahtroopa']" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "member_list = dd.get_member_list()\n", "member_list[:5]" ] }, { "cell_type": "markdown", "id": "72a92090", "metadata": {}, "source": [ "## Overview Functions" ] }, { "cell_type": "markdown", "id": "e27c4557", "metadata": {}, "source": [ "These functions return overviews of different data collected and shared by DeepDAO" ] }, { "cell_type": "markdown", "id": "781aabfa", "metadata": {}, "source": [ "### Get organizations" ] }, { "cell_type": "markdown", "id": "16127a62", "metadata": {}, "source": [ "Returns basic information for all DeepDAO tracked organizations" ] }, { "cell_type": "code", "execution_count": 6, "id": "232408ba", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
idtitledescriptionactivelogocreated_atitems
079f19d88-ed4c-4d25-9e10-f99521140cd6YYDS_BDeepDAO research coming soon1https://deepdao-uploads.s3.us-east-2.amazonaws...2021-09-03T18:02:22.787ZNone
1f452294b-5afc-49eb-9b6b-bdbb892f748bIngravDeepDAO research coming soon1https://deepdao-uploads.s3.us-east-2.amazonaws...2021-11-10T02:57:28.651ZNone
2e08d65fd-8b23-4c54-baf4-42105e2360fbChibi Labs DAOThe official DAO of all Chibi Labs collections.1https://deepdao-uploads.s3.us-east-2.amazonaws...2021-11-11T07:06:04.631ZNone
3f2b515b5-e860-4488-866e-5f9a5ef42c20MateLimit Orders1https://deepdao-uploads.s3.us-east-2.amazonaws...2021-11-12T03:47:52.076ZNone
4fb0c86ff-26b7-488c-af18-e2a9466812f3OtterClamDeepDAO research coming soon1https://deepdao-uploads.s3.us-east-2.amazonaws...2021-11-12T03:47:52.076ZNone
\n", "
" ], "text/plain": [ " id title \\\n", "0 79f19d88-ed4c-4d25-9e10-f99521140cd6 YYDS_B \n", "1 f452294b-5afc-49eb-9b6b-bdbb892f748b Ingrav \n", "2 e08d65fd-8b23-4c54-baf4-42105e2360fb Chibi Labs DAO \n", "3 f2b515b5-e860-4488-866e-5f9a5ef42c20 Mate \n", "4 fb0c86ff-26b7-488c-af18-e2a9466812f3 OtterClam \n", "\n", " description active \\\n", "0 DeepDAO research coming soon 1 \n", "1 DeepDAO research coming soon 1 \n", "2 The official DAO of all Chibi Labs collections. 1 \n", "3 Limit Orders 1 \n", "4 DeepDAO research coming soon 1 \n", "\n", " logo \\\n", "0 https://deepdao-uploads.s3.us-east-2.amazonaws... \n", "1 https://deepdao-uploads.s3.us-east-2.amazonaws... \n", "2 https://deepdao-uploads.s3.us-east-2.amazonaws... \n", "3 https://deepdao-uploads.s3.us-east-2.amazonaws... \n", "4 https://deepdao-uploads.s3.us-east-2.amazonaws... \n", "\n", " created_at items \n", "0 2021-09-03T18:02:22.787Z None \n", "1 2021-11-10T02:57:28.651Z None \n", "2 2021-11-11T07:06:04.631Z None \n", "3 2021-11-12T03:47:52.076Z None \n", "4 2021-11-12T03:47:52.076Z None " ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "organizations = dd.get_organizations()\n", "organizations.head()" ] }, { "cell_type": "markdown", "id": "42af6b41", "metadata": {}, "source": [ "### Get summary" ] }, { "cell_type": "markdown", "id": "208c36fe", "metadata": {}, "source": [ "Returns basic summaries of information for all DeepDAO tracked organizations" ] }, { "cell_type": "code", "execution_count": 7, "id": "798b53bc", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
daoNameorganizationIddaoIdlogototalNumMemberstotalNumProposalstotalNumVoterstotalValueUSDtotalInUSDtotalOutUSDvotersParticipationthumbNameplatform
0DimensionLabc5519131-209d-4b0d-a422-effebb9098cfdimensionlab.aragonid.ethdimension-lab.jpeg1202.265061e+041.000003e+030.000000e+000.0000004
1JuiceboxDAO3c66ac5d-e30a-40c9-be85-8ff659ee53d3jbdao.ethhttps://deepdao-uploads.s3.us-east-2.amazonaws...3618371324.219626e+048.615961e+044.721095e+043.64842512
2Constitutionc050cfb9-67bd-4ebc-b086-4ab57345da2a2a988310-48d5-4809-bc65-622d43fc5f58https://deepdao-uploads.s3.us-east-2.amazonaws...9040001.702046e+045.224207e+071.046350e+08-1.000000-1
3ApocalypseDAO08015cac-5454-4bcf-85d1-5f526b7c88990x44d55a8492a90640dc6af013657eaf1ac5bc9548apocalypsedao.jpg72243.053519e+030.000000e+000.000000e+0057.1428571
4BarnBridge6a15c265-e700-4519-9221-610004c671f20x4cae362d7f227e3d306f70ce4878e245563f3069barnbridgelaunch.jpg1598135.660217e+072.626249e+082.060228e+0886.666667-1
\n", "
" ], "text/plain": [ " daoName organizationId \\\n", "0 DimensionLab c5519131-209d-4b0d-a422-effebb9098cf \n", "1 JuiceboxDAO 3c66ac5d-e30a-40c9-be85-8ff659ee53d3 \n", "2 Constitution c050cfb9-67bd-4ebc-b086-4ab57345da2a \n", "3 ApocalypseDAO 08015cac-5454-4bcf-85d1-5f526b7c8899 \n", "4 BarnBridge 6a15c265-e700-4519-9221-610004c671f2 \n", "\n", " daoId \\\n", "0 dimensionlab.aragonid.eth \n", "1 jbdao.eth \n", "2 2a988310-48d5-4809-bc65-622d43fc5f58 \n", "3 0x44d55a8492a90640dc6af013657eaf1ac5bc9548 \n", "4 0x4cae362d7f227e3d306f70ce4878e245563f3069 \n", "\n", " logo totalNumMembers \\\n", "0 dimension-lab.jpeg 1 \n", "1 https://deepdao-uploads.s3.us-east-2.amazonaws... 3618 \n", "2 https://deepdao-uploads.s3.us-east-2.amazonaws... 9040 \n", "3 apocalypsedao.jpg 7 \n", "4 barnbridgelaunch.jpg 15 \n", "\n", " totalNumProposals totalNumVoters totalValueUSD totalInUSD \\\n", "0 2 0 2.265061e+04 1.000003e+03 \n", "1 37 132 4.219626e+04 8.615961e+04 \n", "2 0 0 1.702046e+04 5.224207e+07 \n", "3 22 4 3.053519e+03 0.000000e+00 \n", "4 98 13 5.660217e+07 2.626249e+08 \n", "\n", " totalOutUSD votersParticipation thumbName platform \n", "0 0.000000e+00 0.000000 4 \n", "1 4.721095e+04 3.648425 12 \n", "2 1.046350e+08 -1.000000 -1 \n", "3 0.000000e+00 57.142857 1 \n", "4 2.060228e+08 86.666667 -1 " ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "summary = dd.get_summary()\n", "summary.head()" ] }, { "cell_type": "markdown", "id": "8c82207f", "metadata": {}, "source": [ "### Get overview" ] }, { "cell_type": "markdown", "id": "f05869df", "metadata": {}, "source": [ "Returns an overview of the DAO ecosystem aggreated by DeepDAO" ] }, { "cell_type": "code", "execution_count": 6, "id": "b212542b", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
aummembersover1Mover50kover10Membersover100Members
2021-11-271.487116e+1014638655874869
2021-11-281.420502e+1014769345874869
2021-11-291.494758e+1016672915873371
2021-11-301.505147e+1016680825873371
2021-12-011.575149e+1016776835872769
\n", "
" ], "text/plain": [ " aum members over1M over50k over10Members \\\n", "2021-11-27 1.487116e+10 1463865 58 7 48 \n", "2021-11-28 1.420502e+10 1476934 58 7 48 \n", "2021-11-29 1.494758e+10 1667291 58 7 33 \n", "2021-11-30 1.505147e+10 1668082 58 7 33 \n", "2021-12-01 1.575149e+10 1677683 58 7 27 \n", "\n", " over100Members \n", "2021-11-27 69 \n", "2021-11-28 69 \n", "2021-11-29 71 \n", "2021-11-30 71 \n", "2021-12-01 69 " ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "overview = dd.get_overview()\n", "overview.tail()" ] }, { "cell_type": "markdown", "id": "2842c9eb", "metadata": {}, "source": [ "### Get rankings" ] }, { "cell_type": "markdown", "id": "85f53a7f", "metadata": {}, "source": [ "The function returns a pandas DataFrame of DAO ranked by different organization metrics" ] }, { "cell_type": "code", "execution_count": 8, "id": "9e9e5954", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
idnamebyAumbyTotalInbyTotalOutbyMembersbyProposalsbyVotersbyParticipationcngAumImmediate...cngOutMonthcngMembersImmediatecngMembersWeekcngMembersMonthcngProposalsImmediatecngProposalsWeekcngProposalsMonthcngVotersImmediatecngVoterssWeekcngVotersMonth
00x5A49Fb12f512451819cAeB7F4bE37e89f0eb0aFdBurn Signal9712912515317117000...-14-13-12100-1500-15
10xb42616e266cb0c6d34c1434f09b95ed50bb551edOrochi DAO V212214013315413514900...-15-13-12-400-1-1000-15
20xee7fa430a7e513d3df962ed0c0e285bc6f87fc24CENNZnet Grants DAO11710910211011410100...-9-10-9-100-500-14
30x016e79e9101a8eaa3e7f46d6d1c267819c09c939Machi X DAO126107104547911202...-1800250-1-500-15
40xbeb3e32355a933501c247e2dbde6e6ca2489bf3dRaid Guild War Chest7481791325670-1...-1000490000-1-14
\n", "

5 rows × 27 columns

\n", "
" ], "text/plain": [ " id name byAum \\\n", "0 0x5A49Fb12f512451819cAeB7F4bE37e89f0eb0aFd Burn Signal 97 \n", "1 0xb42616e266cb0c6d34c1434f09b95ed50bb551ed Orochi DAO V2 122 \n", "2 0xee7fa430a7e513d3df962ed0c0e285bc6f87fc24 CENNZnet Grants DAO 117 \n", "3 0x016e79e9101a8eaa3e7f46d6d1c267819c09c939 Machi X DAO 126 \n", "4 0xbeb3e32355a933501c247e2dbde6e6ca2489bf3d Raid Guild War Chest 74 \n", "\n", " byTotalIn byTotalOut byMembers byProposals byVoters byParticipation \\\n", "0 129 125 153 171 170 0 \n", "1 140 133 154 135 149 0 \n", "2 109 102 110 114 101 0 \n", "3 107 104 54 79 112 0 \n", "4 81 79 13 25 67 0 \n", "\n", " cngAumImmediate ... cngOutMonth cngMembersImmediate cngMembersWeek \\\n", "0 0 ... -14 -13 -12 \n", "1 0 ... -15 -13 -12 \n", "2 0 ... -9 -10 -9 \n", "3 2 ... -18 0 0 \n", "4 -1 ... -10 0 0 \n", "\n", " cngMembersMonth cngProposalsImmediate cngProposalsWeek \\\n", "0 1 0 0 \n", "1 -40 0 -1 \n", "2 -1 0 0 \n", "3 25 0 -1 \n", "4 49 0 0 \n", "\n", " cngProposalsMonth cngVotersImmediate cngVoterssWeek cngVotersMonth \n", "0 -15 0 0 -15 \n", "1 -10 0 0 -15 \n", "2 -5 0 0 -14 \n", "3 -5 0 0 -15 \n", "4 0 0 -1 -14 \n", "\n", "[5 rows x 27 columns]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "rankings = dd.get_rankings()\n", "rankings.head()" ] }, { "cell_type": "markdown", "id": "2d62d637", "metadata": {}, "source": [ "### Get tokens" ] }, { "cell_type": "markdown", "id": "6b6f3acf", "metadata": {}, "source": [ "Returns information about the utilization of different tokens across all DAOs tracked by DeepDAO" ] }, { "cell_type": "code", "execution_count": 9, "id": "0da989f0", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
tokenNametokenSymboltokenDaosnumDaosdaosTotalBalancedaosTotalUsdValue
0UniswapUNI[marsdao.aragonid.eth, 0xa365A8429FceFdbE1E684...131.735275e+083.059293e+09
1BitDAOBIT[sushigov.eth, bitdao.eth]29.034524e+081.801844e+09
2EthereumETH[0x5A49Fb12f512451819cAeB7F4bE37e89f0eb0aFd, 0...932.738264e+051.185703e+09
3Lido DAO TokenLDO[0x0c188B183FF758500D1D18B432313d10e9F6b8a4, y...42.034113e+087.051699e+08
4CompoundCOMP[marsdao.aragonid.eth, trust.aragonid.eth, 0x0...82.947380e+066.495804e+08
\n", "
" ], "text/plain": [ " tokenName tokenSymbol \\\n", "0 Uniswap UNI \n", "1 BitDAO BIT \n", "2 Ethereum ETH \n", "3 Lido DAO Token LDO \n", "4 Compound COMP \n", "\n", " tokenDaos numDaos \\\n", "0 [marsdao.aragonid.eth, 0xa365A8429FceFdbE1E684... 13 \n", "1 [sushigov.eth, bitdao.eth] 2 \n", "2 [0x5A49Fb12f512451819cAeB7F4bE37e89f0eb0aFd, 0... 93 \n", "3 [0x0c188B183FF758500D1D18B432313d10e9F6b8a4, y... 4 \n", "4 [marsdao.aragonid.eth, trust.aragonid.eth, 0x0... 8 \n", "\n", " daosTotalBalance daosTotalUsdValue \n", "0 1.735275e+08 3.059293e+09 \n", "1 9.034524e+08 1.801844e+09 \n", "2 2.738264e+05 1.185703e+09 \n", "3 2.034113e+08 7.051699e+08 \n", "4 2.947380e+06 6.495804e+08 " ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tokens = dd.get_tokens()\n", "tokens.head()" ] }, { "cell_type": "markdown", "id": "c011b08a", "metadata": {}, "source": [ "## DAO Specific Functions" ] }, { "cell_type": "markdown", "id": "1b8a4713", "metadata": {}, "source": [ "These functions return different information for a given DAO or list of DAOs" ] }, { "cell_type": "code", "execution_count": 10, "id": "1139ccc1", "metadata": {}, "outputs": [], "source": [ "# DAOs tracked by Deep DAO\n", "daos = [\"Uniswap\", \"Compound\"]" ] }, { "cell_type": "markdown", "id": "e3c81c00", "metadata": {}, "source": [ "### Get dao info" ] }, { "cell_type": "markdown", "id": "a1ac51fd", "metadata": {}, "source": [ "Returns basic information for a given DAO or list of DAOs" ] }, { "cell_type": "code", "execution_count": 11, "id": "80c07b01", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
UniswapCompound
id4f466e08-9125-40fd-ba15-77552dec7c65a3382dd2-bb02-4aef-845d-f65229ec9e3e
titleUniswapCompound
descriptionNoneNone
isActiveTrueTrue
mainSiteLinkhttps://uniswap.org/https://compound.finance/
logohttps://deepdao-uploads.s3.us-east-2.amazonaws...https://deepdao-uploads.s3.us-east-2.amazonaws...
twitterhttps://twitter.com/Uniswaphttps://twitter.com/compoundfinance
telegramNoneNone
discordhttps://discord.com/invite/FCfyBSbCU5https://discord.com/invite/cU7vmVW
githubhttps://github.com/Uniswaphttps://github.com/compound-finance/compound-p...
createdAt2021-12-08T06:12:47.532Z2021-12-08T06:11:16.990Z
organizationIdfe6aa70f-4877-4f6d-9c18-9a8cafc1fe2852bf381b-79a8-4498-8504-41961beda494
daoId4f466e08-9125-40fd-ba15-77552dec7c65a3382dd2-bb02-4aef-845d-f65229ec9e3e
isDisplayedTrueTrue
platform66
\n", "
" ], "text/plain": [ " Uniswap \\\n", "id 4f466e08-9125-40fd-ba15-77552dec7c65 \n", "title Uniswap \n", "description None \n", "isActive True \n", "mainSiteLink https://uniswap.org/ \n", "logo https://deepdao-uploads.s3.us-east-2.amazonaws... \n", "twitter https://twitter.com/Uniswap \n", "telegram None \n", "discord https://discord.com/invite/FCfyBSbCU5 \n", "github https://github.com/Uniswap \n", "createdAt 2021-12-08T06:12:47.532Z \n", "organizationId fe6aa70f-4877-4f6d-9c18-9a8cafc1fe28 \n", "daoId 4f466e08-9125-40fd-ba15-77552dec7c65 \n", "isDisplayed True \n", "platform 6 \n", "\n", " Compound \n", "id a3382dd2-bb02-4aef-845d-f65229ec9e3e \n", "title Compound \n", "description None \n", "isActive True \n", "mainSiteLink https://compound.finance/ \n", "logo https://deepdao-uploads.s3.us-east-2.amazonaws... \n", "twitter https://twitter.com/compoundfinance \n", "telegram None \n", "discord https://discord.com/invite/cU7vmVW \n", "github https://github.com/compound-finance/compound-p... \n", "createdAt 2021-12-08T06:11:16.990Z \n", "organizationId 52bf381b-79a8-4498-8504-41961beda494 \n", "daoId a3382dd2-bb02-4aef-845d-f65229ec9e3e \n", "isDisplayed True \n", "platform 6 " ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "info = dd.get_dao_info(dao_slugs=daos)\n", "info" ] }, { "cell_type": "markdown", "id": "b145326d", "metadata": {}, "source": [ "### Get dao indices" ] }, { "cell_type": "markdown", "id": "7e3bdfbb", "metadata": {}, "source": [ "Returns financial indices for given DAO(s) like the Gini Index or the Herfindahl–Hirschman index" ] }, { "cell_type": "code", "execution_count": 12, "id": "c1256a89", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
UniswapCompoundOlympus DAOAaveGnosis
giniIndexNoneNone1.000.991.00
HHIndex620.01217.0NoneNoneNone
HHIndexTop201226.02544.0NoneNoneNone
\n", "
" ], "text/plain": [ " Uniswap Compound Olympus DAO Aave Gnosis\n", "giniIndex None None 1.00 0.99 1.00\n", "HHIndex 620.0 1217.0 None None None\n", "HHIndexTop20 1226.0 2544.0 None None None" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "indices = dd.get_dao_indices(dao_slugs=[\"Uniswap\", \"Compound\", \"Olympus DAO\", \"Aave\", \"Gnosis\"])\n", "indices" ] }, { "cell_type": "markdown", "id": "4a2040d2", "metadata": {}, "source": [ "### Get dao proposals" ] }, { "cell_type": "markdown", "id": "789dc5b8", "metadata": {}, "source": [ "Returns information about governance proposals for given DAO(s)" ] }, { "cell_type": "code", "execution_count": 13, "id": "6ce40a66", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Uniswap...Compound
0createdAtdescriptionidproposalNativeIdproposerprotocolAddressremovedstatustitle...proposalNativeIdremovedvotesvotesSharesvotesForvotesForSharesvotesAgainstvotesAgainstSharesvotesAbstainedvotesAbstainedShares
0NaN2021-08-14T01:06:23.000Z# Community-Enabled Analytics\\n\\n*Past discuss...4495d852-fbd8-45ac-9f83-f06a24e0bcad2.00x52886bd557Eb46b70949D7C857230d6a32F6D1190xc4e172459f1e7939d522503b81afaac1014ce6f6FalseProposalCanceled# Community-Enabled Analytics\\n\\n*Past discuss......8False6914278464141295951500000
1NaN2021-06-12T14:33:20.000Z# DeFi Education Fund\\n\\n\\nProposal to allocat...53dfbd23-c648-4f9c-9fd5-2ab2b2f388925.00x61c8D4e4BE6477Bb49791540Ff297Ef30Eaa01c20x5e4be8bc9637f0eaa1a755019e06a68ce081d58fFalseProposalCreated# DeFi Education Fund\\n\\n\\nProposal to allocat......60False38124952331093829415100014773
2NaN2020-12-17T23:59:31.000Zhttps://snapshot.page/#/uniswap/proposal/QmQJu...68e94b70-0a69-468c-a022-412fa21f244b3.00x76f54Eeb0D33a2A2c5CCb72FE12542A56f35d67C0x5e4be8bc9637f0eaa1a755019e06a68ce081d58fFalseProposalExecutedhttps://snapshot.page/#/uniswap/proposal/QmQJu......48False00000000
3NaN2020-10-12T18:08:52.000Z# Reduce UNI Governance Proposal & Quorum Thre...7617cc36-375a-48dc-8170-6c8fcaa442621.00x7e4A8391C728fEd9069B2962699AB416628B19Fa0x5e4be8bc9637f0eaa1a755019e06a68ce081d58fFalseProposalCreated# Reduce UNI Governance Proposal & Quorum Thre......62False2972972287297610010
4NaN2021-06-22T22:07:36.000Z# DeFi Education Fund\\n\\n#### (Previously know...855e9e7e-42f5-4e11-96bd-e32a0fc964571.00x61c8D4e4BE6477Bb49791540Ff297Ef30Eaa01c20xc4e172459f1e7939d522503b81afaac1014ce6f6FalseProposalExecuted# DeFi Education Fund\\n\\n#### (Previously know......16False104105779845339432052395000
\n", "

5 rows × 35 columns

\n", "
" ], "text/plain": [ " Uniswap \\\n", " 0 createdAt \n", "0 NaN 2021-08-14T01:06:23.000Z \n", "1 NaN 2021-06-12T14:33:20.000Z \n", "2 NaN 2020-12-17T23:59:31.000Z \n", "3 NaN 2020-10-12T18:08:52.000Z \n", "4 NaN 2021-06-22T22:07:36.000Z \n", "\n", " \\\n", " description \n", "0 # Community-Enabled Analytics\\n\\n*Past discuss... \n", "1 # DeFi Education Fund\\n\\n\\nProposal to allocat... \n", "2 https://snapshot.page/#/uniswap/proposal/QmQJu... \n", "3 # Reduce UNI Governance Proposal & Quorum Thre... \n", "4 # DeFi Education Fund\\n\\n#### (Previously know... \n", "\n", " \\\n", " id proposalNativeId \n", "0 4495d852-fbd8-45ac-9f83-f06a24e0bcad 2.0 \n", "1 53dfbd23-c648-4f9c-9fd5-2ab2b2f38892 5.0 \n", "2 68e94b70-0a69-468c-a022-412fa21f244b 3.0 \n", "3 7617cc36-375a-48dc-8170-6c8fcaa44262 1.0 \n", "4 855e9e7e-42f5-4e11-96bd-e32a0fc96457 1.0 \n", "\n", " \\\n", " proposer \n", "0 0x52886bd557Eb46b70949D7C857230d6a32F6D119 \n", "1 0x61c8D4e4BE6477Bb49791540Ff297Ef30Eaa01c2 \n", "2 0x76f54Eeb0D33a2A2c5CCb72FE12542A56f35d67C \n", "3 0x7e4A8391C728fEd9069B2962699AB416628B19Fa \n", "4 0x61c8D4e4BE6477Bb49791540Ff297Ef30Eaa01c2 \n", "\n", " \\\n", " protocolAddress removed status \n", "0 0xc4e172459f1e7939d522503b81afaac1014ce6f6 False ProposalCanceled \n", "1 0x5e4be8bc9637f0eaa1a755019e06a68ce081d58f False ProposalCreated \n", "2 0x5e4be8bc9637f0eaa1a755019e06a68ce081d58f False ProposalExecuted \n", "3 0x5e4be8bc9637f0eaa1a755019e06a68ce081d58f False ProposalCreated \n", "4 0xc4e172459f1e7939d522503b81afaac1014ce6f6 False ProposalExecuted \n", "\n", " ... Compound \\\n", " title ... proposalNativeId \n", "0 # Community-Enabled Analytics\\n\\n*Past discuss... ... 8 \n", "1 # DeFi Education Fund\\n\\n\\nProposal to allocat... ... 60 \n", "2 https://snapshot.page/#/uniswap/proposal/QmQJu... ... 48 \n", "3 # Reduce UNI Governance Proposal & Quorum Thre... ... 62 \n", "4 # DeFi Education Fund\\n\\n#### (Previously know... ... 16 \n", "\n", " \\\n", " removed votes votesShares votesFor votesForShares votesAgainst \n", "0 False 69 142784 64 1412959 5 \n", "1 False 38 124952 33 1093829 4 \n", "2 False 0 0 0 0 0 \n", "3 False 29 72972 28 729761 0 \n", "4 False 104 105779 84 533943 20 \n", "\n", " \n", " votesAgainstShares votesAbstained votesAbstainedShares \n", "0 15000 0 0 \n", "1 151000 1 4773 \n", "2 0 0 0 \n", "3 0 1 0 \n", "4 523950 0 0 \n", "\n", "[5 rows x 35 columns]" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "proposals = dd.get_dao_proposals(dao_slugs=daos)\n", "proposals.head()" ] }, { "cell_type": "markdown", "id": "61792305", "metadata": {}, "source": [ "### Get dao members" ] }, { "cell_type": "markdown", "id": "8737dfa2", "metadata": {}, "source": [ "Returns information about the Members of given DAO(s) and their respective token balances" ] }, { "cell_type": "code", "execution_count": 14, "id": "663cc437", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Uniswap...Compound
0balancememberAddressproposalsCreatedproposalsVotedproposalsVotedAbstainedproposalsVotedAgainstproposalsVotedForvotesAbstainedSharesvotesAgainstShares...balanceproposalsCreatedproposalsVotedproposalsVotedForproposalsVotedAgainstproposalsVotedAbstainedvotesSharesvotesForSharesvotesAgainstSharesvotesAbstainedShares
0NaN1609915.00x1494ca1f11d487c2bbe4543e90080aeba4ba3c2b0.011.00.01.010.0020086...0055000000
1NaN3400635.00xa29332b560103d52f758b978e0661420a9d40cb50.03.00.02.01.001088203...00110048048000
2NaN1004714.00x04ae7e5019555dd1d54fb8c482b0a399ef80cc7e0.00.00.00.00.000...0011000000
3NaN2149576.00x0739e7abe029434c4357e247a397d80b64301ef90.00.00.00.00.000...0011000000
4NaN1600000.00x087256f28f0d9762b89d4549301df4b7e7b5cda30.00.00.00.00.000...0000000000
\n", "

5 rows × 23 columns

\n", "
" ], "text/plain": [ " Uniswap \\\n", " 0 balance memberAddress \n", "0 NaN 1609915.0 0x1494ca1f11d487c2bbe4543e90080aeba4ba3c2b \n", "1 NaN 3400635.0 0xa29332b560103d52f758b978e0661420a9d40cb5 \n", "2 NaN 1004714.0 0x04ae7e5019555dd1d54fb8c482b0a399ef80cc7e \n", "3 NaN 2149576.0 0x0739e7abe029434c4357e247a397d80b64301ef9 \n", "4 NaN 1600000.0 0x087256f28f0d9762b89d4549301df4b7e7b5cda3 \n", "\n", " \\\n", " proposalsCreated proposalsVoted proposalsVotedAbstained \n", "0 0.0 11.0 0.0 \n", "1 0.0 3.0 0.0 \n", "2 0.0 0.0 0.0 \n", "3 0.0 0.0 0.0 \n", "4 0.0 0.0 0.0 \n", "\n", " \\\n", " proposalsVotedAgainst proposalsVotedFor votesAbstainedShares \n", "0 1.0 10.0 0 \n", "1 2.0 1.0 0 \n", "2 0.0 0.0 0 \n", "3 0.0 0.0 0 \n", "4 0.0 0.0 0 \n", "\n", " ... Compound \\\n", " votesAgainstShares ... balance proposalsCreated proposalsVoted \n", "0 20086 ... 0 0 5 \n", "1 1088203 ... 0 0 1 \n", "2 0 ... 0 0 1 \n", "3 0 ... 0 0 1 \n", "4 0 ... 0 0 0 \n", "\n", " \\\n", " proposalsVotedFor proposalsVotedAgainst proposalsVotedAbstained votesShares \n", "0 5 0 0 0 \n", "1 1 0 0 480 \n", "2 1 0 0 0 \n", "3 1 0 0 0 \n", "4 0 0 0 0 \n", "\n", " \n", " votesForShares votesAgainstShares votesAbstainedShares \n", "0 0 0 0 \n", "1 480 0 0 \n", "2 0 0 0 \n", "3 0 0 0 \n", "4 0 0 0 \n", "\n", "[5 rows x 23 columns]" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "members = dd.get_dao_members(dao_slugs=daos)\n", "members.head()" ] }, { "cell_type": "markdown", "id": "bb63f8e9", "metadata": {}, "source": [ "### Get dao voter coalitions" ] }, { "cell_type": "markdown", "id": "1c2eca9c", "metadata": {}, "source": [ "Returns information about different voting coalitions for given DAO(s)" ] }, { "cell_type": "code", "execution_count": 15, "id": "9f62c9a7", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
UniswapCompound
coalitionsubsetLengthtimesVotedTogethertimesVotedTogetherFortimesVotedTogetherAgainstcoalitionsubsetLengthtimesVotedTogethertimesVotedTogetherFortimesVotedTogetherAgainst
00xb40ff1ca580090b386048228ae7140b0dde7f1c5, 0x...27520x54a37d93e57c5da659f508069cf65a381b61e189, 0x...2554510
10x84bb5196f0085d61a7c9ac5b903a26d7f009ac13, 0x...26060x84e39a52d7f3f8fb63723782653d4cf71c465a95, 0x...245414
20x2533321a436578c60a176bd7cb0f9b2590a98ea1, 0x...26060x54a37d93e57c5da659f508069cf65a381b61e189, 0x...243394
30x5d8908afee1df9f7f0830105f8be828f97ce9e68, 0x...25320x84e39a52d7f3f8fb63723782653d4cf71c465a95, 0x...243430
40xa29332b560103d52f758b978e0661420a9d40cb5, 0x...25140x54a37d93e57c5da659f508069cf65a381b61e189, 0x...242402
\n", "
" ], "text/plain": [ " Uniswap \\\n", " coalition subsetLength \n", "0 0xb40ff1ca580090b386048228ae7140b0dde7f1c5, 0x... 2 \n", "1 0x84bb5196f0085d61a7c9ac5b903a26d7f009ac13, 0x... 2 \n", "2 0x2533321a436578c60a176bd7cb0f9b2590a98ea1, 0x... 2 \n", "3 0x5d8908afee1df9f7f0830105f8be828f97ce9e68, 0x... 2 \n", "4 0xa29332b560103d52f758b978e0661420a9d40cb5, 0x... 2 \n", "\n", " \\\n", " timesVotedTogether timesVotedTogetherFor timesVotedTogetherAgainst \n", "0 7 5 2 \n", "1 6 0 6 \n", "2 6 0 6 \n", "3 5 3 2 \n", "4 5 1 4 \n", "\n", " Compound \\\n", " coalition subsetLength \n", "0 0x54a37d93e57c5da659f508069cf65a381b61e189, 0x... 2 \n", "1 0x84e39a52d7f3f8fb63723782653d4cf71c465a95, 0x... 2 \n", "2 0x54a37d93e57c5da659f508069cf65a381b61e189, 0x... 2 \n", "3 0x84e39a52d7f3f8fb63723782653d4cf71c465a95, 0x... 2 \n", "4 0x54a37d93e57c5da659f508069cf65a381b61e189, 0x... 2 \n", "\n", " \n", " timesVotedTogether timesVotedTogetherFor timesVotedTogetherAgainst \n", "0 55 45 10 \n", "1 45 41 4 \n", "2 43 39 4 \n", "3 43 43 0 \n", "4 42 40 2 " ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "coalitions = dd.get_dao_voter_coalitions(dao_slugs=daos)\n", "coalitions.head()" ] }, { "cell_type": "markdown", "id": "bf05dcd2", "metadata": {}, "source": [ "### Get dao financials" ] }, { "cell_type": "markdown", "id": "f4cebd22", "metadata": {}, "source": [ "Returns information about the treasury composition of given DAO(s)" ] }, { "cell_type": "code", "execution_count": 16, "id": "0d8d50eb", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
UniswapCompound
totalIntotalInUSDtotalOuttotalOutUSDtokenSymboltokenBalancetokenNameusdPriceusdValuetokenAddresstotalIntotalInUSDtotalOuttotalOutUSDtokenSymboltokenBalancetokenNameusdPriceusdValuetokenAddress
00.000000e+000.000000e+000.00.000000e+00ETH1.659834e-03Ethereum4.330122e+037.187282e+00NaN5.299795e-022.294876e+020.000000e+000.000000e+00ETH0.000000e+00Ethereum4330.1216710.000000e+00NaN
13.469227e+086.116253e+09173519500.03.059152e+09UNI1.734032e+08Uniswap1.763002e+013.057101e+090x1f9840a85d5af5bf1d1762f925bdaddc4201f9846.115681e+061.347850e+093.168359e+066.982824e+08COMP2.947322e+06Compound220.3924886.495677e+080xc00e94cb662c3520282e6f5717214004a7f26888
29.000000e+016.299128e+000.00.000000e+00ACE9.000000e+01ACENT6.999031e-026.299128e+000xec5483804e637d45cde22fa0869656b64b5ab1ab3.505146e+034.506155e+030.000000e+000.000000e+00BAT3.505146e+03BAT1.2855834.506155e+030x0d8775f648430679a709e98d2b0cb6250d2887ef
32.000000e+013.140000e+010.00.000000e+00WJXN2.000000e+01Wrapped JAXNET1.570000e+003.140000e+010xca1262e77fb25c0a4112cfc9bad3ff54f617f2e61.711724e+021.711724e+020.000000e+000.000000e+00SAI1.711724e+02Sai Stablecoin v1.01.0000001.711724e+020x89d24a6b4ccb1b6faa2625fe562bdd9a23260359
47.350000e+023.484708e-040.00.000000e+00SDOG7.350000e+02SDOG4.741100e-073.484708e-040x537edd52ebcb9f48ff2f8a28c51fcdb9d6a6e0d45.000000e+027.321177e-040.000000e+000.000000e+00FREE5.000000e+02Free Coin0.0000017.321177e-040x2f141ce366a2462f02cea3d12cf93e4dca49e4fd
\n", "
" ], "text/plain": [ " Uniswap \\\n", " totalIn totalInUSD totalOut totalOutUSD tokenSymbol \n", "0 0.000000e+00 0.000000e+00 0.0 0.000000e+00 ETH \n", "1 3.469227e+08 6.116253e+09 173519500.0 3.059152e+09 UNI \n", "2 9.000000e+01 6.299128e+00 0.0 0.000000e+00 ACE \n", "3 2.000000e+01 3.140000e+01 0.0 0.000000e+00 WJXN \n", "4 7.350000e+02 3.484708e-04 0.0 0.000000e+00 SDOG \n", "\n", " \\\n", " tokenBalance tokenName usdPrice usdValue \n", "0 1.659834e-03 Ethereum 4.330122e+03 7.187282e+00 \n", "1 1.734032e+08 Uniswap 1.763002e+01 3.057101e+09 \n", "2 9.000000e+01 ACENT 6.999031e-02 6.299128e+00 \n", "3 2.000000e+01 Wrapped JAXNET 1.570000e+00 3.140000e+01 \n", "4 7.350000e+02 SDOG 4.741100e-07 3.484708e-04 \n", "\n", " Compound \\\n", " tokenAddress totalIn totalInUSD \n", "0 NaN 5.299795e-02 2.294876e+02 \n", "1 0x1f9840a85d5af5bf1d1762f925bdaddc4201f984 6.115681e+06 1.347850e+09 \n", "2 0xec5483804e637d45cde22fa0869656b64b5ab1ab 3.505146e+03 4.506155e+03 \n", "3 0xca1262e77fb25c0a4112cfc9bad3ff54f617f2e6 1.711724e+02 1.711724e+02 \n", "4 0x537edd52ebcb9f48ff2f8a28c51fcdb9d6a6e0d4 5.000000e+02 7.321177e-04 \n", "\n", " \\\n", " totalOut totalOutUSD tokenSymbol tokenBalance tokenName \n", "0 0.000000e+00 0.000000e+00 ETH 0.000000e+00 Ethereum \n", "1 3.168359e+06 6.982824e+08 COMP 2.947322e+06 Compound \n", "2 0.000000e+00 0.000000e+00 BAT 3.505146e+03 BAT \n", "3 0.000000e+00 0.000000e+00 SAI 1.711724e+02 Sai Stablecoin v1.0 \n", "4 0.000000e+00 0.000000e+00 FREE 5.000000e+02 Free Coin \n", "\n", " \n", " usdPrice usdValue tokenAddress \n", "0 4330.121671 0.000000e+00 NaN \n", "1 220.392488 6.495677e+08 0xc00e94cb662c3520282e6f5717214004a7f26888 \n", "2 1.285583 4.506155e+03 0x0d8775f648430679a709e98d2b0cb6250d2887ef \n", "3 1.000000 1.711724e+02 0x89d24a6b4ccb1b6faa2625fe562bdd9a23260359 \n", "4 0.000001 7.321177e-04 0x2f141ce366a2462f02cea3d12cf93e4dca49e4fd " ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "financials = dd.get_dao_financials(dao_slugs=daos)\n", "financials.head()" ] }, { "cell_type": "markdown", "id": "7cdddaf0", "metadata": {}, "source": [ "## Members Specific Functions" ] }, { "cell_type": "markdown", "id": "89b18c2b", "metadata": {}, "source": [ "These functions return information about DAO Members" ] }, { "cell_type": "code", "execution_count": 17, "id": "579ebdf5", "metadata": {}, "outputs": [], "source": [ "# pubkey's for users active in governanace\n", "pubkeys = [\"Ven Gist\", \"scottrepreneur\"]" ] }, { "cell_type": "markdown", "id": "07a51387", "metadata": {}, "source": [ "### Get top members" ] }, { "cell_type": "markdown", "id": "1d207be7", "metadata": {}, "source": [ "Returns a dataframe of basic information for the the top 'count' Members tracked by DeepDAO amount of DAO's particpating in. count default is 10" ] }, { "cell_type": "code", "execution_count": 18, "id": "75932caa", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
addressnamedescriptionavataraumrankdaoAmountproposalsAmountvotesAmountparticipationScoredaos
00xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9Ven GistDesign Thinking & Execution re: Blockchains IRLhttps://ipfs.io/ipfs/QmX5zzpTqkr1Nc8WtSX5kiqaK...189086.55127322190{'daos': [{'id': 'a3382dd2-bb02-4aef-845d-f652...
10x68d36dcbdd7bbf206e27134f28103abe7cf972dfscottrepreneurNonehttps://ipfs.io/ipfs/QmTTuFfjez1z6i7nYGaxJvi7C...470902.4022434680{'daos': [{'id': 'a3382dd2-bb02-4aef-845d-f652...
20x865c2f85c9fea1c6ac7f53de07554d68cb92ed88Peter 'pet3rpan'MetaCartel.https://ipfs.io/ipfs/QmYxQz6ihvTX6JZBqANn7rzcw...182924.133221141710{'daos': [{'id': 'badger.aragonid.eth', 'aum':...
30xced608aa29bb92185d9b6340adcbfa263dae075bDekePokemol/daohaus/metacartel/RaidGuildhttps://ipfs.io/ipfs/QmZSdi7FdSkX8DpXRgEcyDFwC...130558.3941838980{'daos': [{'id': 'badger.aragonid.eth', 'aum':...
40x5b93ff82faaf241c15997ea3975419dddd8362c5CoopahtroopaChance favors the connected mindhttps://ipfs.io/ipfs/QmdzD4jg1JviKU3FkKNePH9sv...420974.80517231210{'daos': [{'id': 'badger.aragonid.eth', 'aum':...
\n", "
" ], "text/plain": [ " address name \\\n", "0 0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9 Ven Gist \n", "1 0x68d36dcbdd7bbf206e27134f28103abe7cf972df scottrepreneur \n", "2 0x865c2f85c9fea1c6ac7f53de07554d68cb92ed88 Peter 'pet3rpan' \n", "3 0xced608aa29bb92185d9b6340adcbfa263dae075b Deke \n", "4 0x5b93ff82faaf241c15997ea3975419dddd8362c5 Coopahtroopa \n", "\n", " description \\\n", "0 Design Thinking & Execution re: Blockchains IRL \n", "1 None \n", "2 MetaCartel. \n", "3 Pokemol/daohaus/metacartel/RaidGuild \n", "4 Chance favors the connected mind \n", "\n", " avatar aum rank \\\n", "0 https://ipfs.io/ipfs/QmX5zzpTqkr1Nc8WtSX5kiqaK... 189086.55 1 \n", "1 https://ipfs.io/ipfs/QmTTuFfjez1z6i7nYGaxJvi7C... 470902.40 2 \n", "2 https://ipfs.io/ipfs/QmYxQz6ihvTX6JZBqANn7rzcw... 182924.13 3 \n", "3 https://ipfs.io/ipfs/QmZSdi7FdSkX8DpXRgEcyDFwC... 130558.39 4 \n", "4 https://ipfs.io/ipfs/QmdzD4jg1JviKU3FkKNePH9sv... 420974.80 5 \n", "\n", " daoAmount proposalsAmount votesAmount participationScore \\\n", "0 27 32 219 0 \n", "1 24 34 68 0 \n", "2 22 114 171 0 \n", "3 18 38 98 0 \n", "4 17 23 121 0 \n", "\n", " daos \n", "0 {'daos': [{'id': 'a3382dd2-bb02-4aef-845d-f652... \n", "1 {'daos': [{'id': 'a3382dd2-bb02-4aef-845d-f652... \n", "2 {'daos': [{'id': 'badger.aragonid.eth', 'aum':... \n", "3 {'daos': [{'id': 'badger.aragonid.eth', 'aum':... \n", "4 {'daos': [{'id': 'badger.aragonid.eth', 'aum':... " ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "people = dd.get_top_members(count=10)\n", "people.head()" ] }, { "cell_type": "markdown", "id": "26c4dea7", "metadata": {}, "source": [ "### Get member info" ] }, { "cell_type": "markdown", "id": "31aac75e", "metadata": {}, "source": [ "Returns basic information for given member(s)" ] }, { "cell_type": "code", "execution_count": 19, "id": "3d8eaf18", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Ven Gistscottrepreneur
address0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b90x68d36dcbdd7bbf206e27134f28103abe7cf972df
nameVen Gistscottrepreneur
descriptionDesign Thinking & Execution re: Blockchains IRLNone
websiteNoneNone
avatarhttps://ipfs.io/ipfs/QmX5zzpTqkr1Nc8WtSX5kiqaK...https://ipfs.io/ipfs/QmTTuFfjez1z6i7nYGaxJvi7C...
daoAmount2724
proposalsAmount3234
votesAmount21968
aum189086.55470902.4
createdAt2021-09-01T11:49:32.011Z2021-09-01T11:49:32.011Z
daos[{'name': 'Compound', 'aum': 1591634524.52387,...[{'name': 'Compound', 'aum': 1591634524.52387,...
twitterNonehttps://twitter.com/scottrepreneur
githubhttps://gist.githubusercontent.com/scottrepren...
participationScoreNoneNone
totalAum189086.55470902.4
totalDaos2724
totalProposals3234
totalVotes21968
tokens[{'usd': 43731.07, 'logo': None, 'name': 'Ethe...[{'usd': 156368.27, 'logo': None, 'name': 'Cry...
\n", "
" ], "text/plain": [ " Ven Gist \\\n", "address 0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9 \n", "name Ven Gist \n", "description Design Thinking & Execution re: Blockchains IRL \n", "website None \n", "avatar https://ipfs.io/ipfs/QmX5zzpTqkr1Nc8WtSX5kiqaK... \n", "daoAmount 27 \n", "proposalsAmount 32 \n", "votesAmount 219 \n", "aum 189086.55 \n", "createdAt 2021-09-01T11:49:32.011Z \n", "daos [{'name': 'Compound', 'aum': 1591634524.52387,... \n", "twitter None \n", "github \n", "participationScore None \n", "totalAum 189086.55 \n", "totalDaos 27 \n", "totalProposals 32 \n", "totalVotes 219 \n", "tokens [{'usd': 43731.07, 'logo': None, 'name': 'Ethe... \n", "\n", " scottrepreneur \n", "address 0x68d36dcbdd7bbf206e27134f28103abe7cf972df \n", "name scottrepreneur \n", "description None \n", "website None \n", "avatar https://ipfs.io/ipfs/QmTTuFfjez1z6i7nYGaxJvi7C... \n", "daoAmount 24 \n", "proposalsAmount 34 \n", "votesAmount 68 \n", "aum 470902.4 \n", "createdAt 2021-09-01T11:49:32.011Z \n", "daos [{'name': 'Compound', 'aum': 1591634524.52387,... \n", "twitter https://twitter.com/scottrepreneur \n", "github https://gist.githubusercontent.com/scottrepren... \n", "participationScore None \n", "totalAum 470902.4 \n", "totalDaos 24 \n", "totalProposals 34 \n", "totalVotes 68 \n", "tokens [{'usd': 156368.27, 'logo': None, 'name': 'Cry... " ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "members = dd.get_member_info(pubkeys=pubkeys)\n", "members" ] }, { "cell_type": "markdown", "id": "cdad97a1", "metadata": {}, "source": [ "### Get member proposals" ] }, { "cell_type": "markdown", "id": "1b799860", "metadata": {}, "source": [ "Returns proposal history for given member(s)" ] }, { "cell_type": "code", "execution_count": 20, "id": "1999506a", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Ven Gist...scottrepreneur
proposalNativeIdcreatedAttitledescriptionproposerIdorganizationIdfirstNamemiddleNamelastNameuserPicture...avatarstatusspaceIdspaceNameurllogofeedActivespaceKeyuserNamepostUrl
00x1b3d7efb93ec432b0d1d56880c23303979b379e9-pro...2021-03-08T16:50:57.000Zfunding proposal DADA.artGrant winner0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b978381bd1-dbfc-46c3-ba1e-eab340417514NoneNoneNoneNone...NoneACCEPTEDNaNNaNNaNNaNNaNNaNNaNNaN
10x1fd169a4f5c59acf79d0fd5d91d1201ef1bce9f1-pro...2021-08-27T17:12:50.000ZShares for V2 MigrationMigrating funds to the V2 Moloch0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9645a478e-4244-46c0-8e3a-ca6492546e47NoneNoneNoneNone...NoneACCEPTEDNaNNaNNaNNaNNaNNaNNaNNaN
20x1fd169a4f5c59acf79d0fd5d91d1201ef1bce9f1-pro...2020-06-17T16:26:50.000ZMGP 46: $12000 for The Minion (Raid Guild)https://docs.google.com/document/d/1i7mwEKX_az...0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9645a478e-4244-46c0-8e3a-ca6492546e47NoneNoneNoneNone...NoneACCEPTEDNaNNaNNaNNaNNaNNaNNaNNaN
30x1fd169a4f5c59acf79d0fd5d91d1201ef1bce9f1-pro...2019-12-17T23:49:25.000ZMGP 30: Odyssy to further Moloch toward a comp...https://molochdao.discourse.group/t/mgp-odyssy...0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9645a478e-4244-46c0-8e3a-ca6492546e47NoneNoneNoneNone...NoneREJECTEDNaNNaNNaNNaNNaNNaNNaNNaN
40x2004cb1e8fb6d4476acdc9e1d37f717d3a83384d-pro...2021-03-12T21:45:55.000ZCCO contribution!--0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9db8f02f3-ebc1-407a-9d20-778ea32faa70NoneNoneNoneNone...NoneACCEPTEDNaNNaNNaNNaNNaNNaNNaNNaN
\n", "

5 rows × 56 columns

\n", "
" ], "text/plain": [ " Ven Gist \\\n", " proposalNativeId \n", "0 0x1b3d7efb93ec432b0d1d56880c23303979b379e9-pro... \n", "1 0x1fd169a4f5c59acf79d0fd5d91d1201ef1bce9f1-pro... \n", "2 0x1fd169a4f5c59acf79d0fd5d91d1201ef1bce9f1-pro... \n", "3 0x1fd169a4f5c59acf79d0fd5d91d1201ef1bce9f1-pro... \n", "4 0x2004cb1e8fb6d4476acdc9e1d37f717d3a83384d-pro... \n", "\n", " \\\n", " createdAt \n", "0 2021-03-08T16:50:57.000Z \n", "1 2021-08-27T17:12:50.000Z \n", "2 2020-06-17T16:26:50.000Z \n", "3 2019-12-17T23:49:25.000Z \n", "4 2021-03-12T21:45:55.000Z \n", "\n", " \\\n", " title \n", "0 funding proposal DADA.art \n", "1 Shares for V2 Migration \n", "2 MGP 46: $12000 for The Minion (Raid Guild) \n", "3 MGP 30: Odyssy to further Moloch toward a comp... \n", "4 CCO contribution! \n", "\n", " \\\n", " description \n", "0 Grant winner \n", "1 Migrating funds to the V2 Moloch \n", "2 https://docs.google.com/document/d/1i7mwEKX_az... \n", "3 https://molochdao.discourse.group/t/mgp-odyssy... \n", "4 -- \n", "\n", " \\\n", " proposerId \n", "0 0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9 \n", "1 0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9 \n", "2 0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9 \n", "3 0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9 \n", "4 0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9 \n", "\n", " \\\n", " organizationId firstName middleName lastName \n", "0 78381bd1-dbfc-46c3-ba1e-eab340417514 None None None \n", "1 645a478e-4244-46c0-8e3a-ca6492546e47 None None None \n", "2 645a478e-4244-46c0-8e3a-ca6492546e47 None None None \n", "3 645a478e-4244-46c0-8e3a-ca6492546e47 None None None \n", "4 db8f02f3-ebc1-407a-9d20-778ea32faa70 None None None \n", "\n", " ... scottrepreneur \\\n", " userPicture ... avatar status spaceId spaceName url logo \n", "0 None ... None ACCEPTED NaN NaN NaN NaN \n", "1 None ... None ACCEPTED NaN NaN NaN NaN \n", "2 None ... None ACCEPTED NaN NaN NaN NaN \n", "3 None ... None REJECTED NaN NaN NaN NaN \n", "4 None ... None ACCEPTED NaN NaN NaN NaN \n", "\n", " \n", " feedActive spaceKey userName postUrl \n", "0 NaN NaN NaN NaN \n", "1 NaN NaN NaN NaN \n", "2 NaN NaN NaN NaN \n", "3 NaN NaN NaN NaN \n", "4 NaN NaN NaN NaN \n", "\n", "[5 rows x 56 columns]" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "member_proposals = dd.get_member_proposals(pubkeys=pubkeys)\n", "member_proposals.head()" ] }, { "cell_type": "markdown", "id": "5eabb009", "metadata": {}, "source": [ "### Get member votes" ] }, { "cell_type": "markdown", "id": "602652c8", "metadata": {}, "source": [ "Returns voting history for given member(s)" ] }, { "cell_type": "code", "execution_count": 21, "id": "8fe30c36", "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Ven Gist...scottrepreneur
proposalIdcreatedAtdaoIddaoNamedaoLogoorganizationIdproposerIdproposerNameproposerAvatartitle...organizationIdproposerIdproposerNameproposerAvatartitledescriptionvotesCountstatusvoteNativeIdvoteChoice
00xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1-pro...2020-03-26T22:15:44.000Z0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1Raid GuildRaidGuild.jpg3a5bc696-1c33-49a8-9cee-ba8089da6a6b0x66b1de0f14a0ce971f7f248415063d44caf19398Yalorhttps://ipfs.io/ipfs/QmbK3qEYJCiyjUCjGpLLsk7bi...Raid <>Dragon Quest Bounties...8c21c472-1533-4e88-9119-6266e0fcb1580x865c2f85c9fea1c6ac7f53de07554d68cb92ed88Peter 'pet3rpan'https://ipfs.io/ipfs/QmYxQz6ihvTX6JZBqANn7rzcw...Monthly Paladins Circle RewardMonthly Paladins Circle Reward2ACCEPTED0x0372f3696fa7dc99801f435fd6737e57818239f2-mem...1.0
10xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1-pro...2020-03-24T00:25:30.000Z0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1Raid GuildRaidGuild.jpg3a5bc696-1c33-49a8-9cee-ba8089da6a6b0x66b1de0f14a0ce971f7f248415063d44caf19398Yalorhttps://ipfs.io/ipfs/QmbK3qEYJCiyjUCjGpLLsk7bi...New Member: Burrrata (@Burrrata)...8c21c472-1533-4e88-9119-6266e0fcb1580xc7f459c7edcf9333d223bd1c346f46819403ca06Sydneyhttps://ipfs.io/ipfs/QmZH5GGr5vbX2S1sRHZFsf2iZ...Meta Gamma Delta ΜΓΔA buidl sorority that supports dope projects m...4ACCEPTED0x0372f3696fa7dc99801f435fd6737e57818239f2-mem...1.0
20xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1-pro...2020-03-10T21:09:20.000Z0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1Raid GuildRaidGuild.jpg3a5bc696-1c33-49a8-9cee-ba8089da6a6b0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9Ven Gisthttps://ipfs.io/ipfs/QmX5zzpTqkr1Nc8WtSX5kiqaK...New Member: Felipe (@duartedao)...8c21c472-1533-4e88-9119-6266e0fcb1580x865c2f85c9fea1c6ac7f53de07554d68cb92ed88Peter 'pet3rpan'https://ipfs.io/ipfs/QmYxQz6ihvTX6JZBqANn7rzcw...DAO Membership Proposal #58: Jon Thttps://forum.metacartel.org/t/dao-membership-...3ACCEPTED0x0372f3696fa7dc99801f435fd6737e57818239f2-mem...1.0
30xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1-pro...2020-03-10T17:58:20.000Z0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1Raid GuildRaidGuild.jpg3a5bc696-1c33-49a8-9cee-ba8089da6a6b0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9Ven Gisthttps://ipfs.io/ipfs/QmX5zzpTqkr1Nc8WtSX5kiqaK...Funding: Raid Guild Tshirt Reimbursement...ba288cda-5c0e-4cea-90ca-104824d7e42b0xced608aa29bb92185d9b6340adcbfa263dae075bDekehttps://ipfs.io/ipfs/QmZSdi7FdSkX8DpXRgEcyDFwC...xDai DAO MigrationxDai or bust. Transfer all funds to xDai dao. ...7ACCEPTED0xdec090a12f2e280b089daa225892d9efa8ed0ee8-mem...1.0
40xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1-pro...2020-03-10T17:42:27.000Z0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1Raid GuildRaidGuild.jpg3a5bc696-1c33-49a8-9cee-ba8089da6a6b0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9Ven Gisthttps://ipfs.io/ipfs/QmX5zzpTqkr1Nc8WtSX5kiqaK...New Member: Lili (@lililashka)...4c7bad27-7ae1-4a39-ad8c-6cc776ef2d1a0xfb3d6b83e51a08ca89dcfe853e7ccbf5ee6ffbf40xfb3d...fbf4NoneMinion sends a tokenAugust Retry1ACCEPTED0xc8e0d7fd13eb3cbc19eb293d0e00b8386cc1b6f2-mem...1.0
\n", "

5 rows × 30 columns

\n", "
" ], "text/plain": [ " Ven Gist \\\n", " proposalId \n", "0 0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1-pro... \n", "1 0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1-pro... \n", "2 0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1-pro... \n", "3 0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1-pro... \n", "4 0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1-pro... \n", "\n", " \\\n", " createdAt daoId \n", "0 2020-03-26T22:15:44.000Z 0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1 \n", "1 2020-03-24T00:25:30.000Z 0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1 \n", "2 2020-03-10T21:09:20.000Z 0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1 \n", "3 2020-03-10T17:58:20.000Z 0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1 \n", "4 2020-03-10T17:42:27.000Z 0xbd6fa666fbb6fdeb4fc5eb36cdd5c87b069b24c1 \n", "\n", " \\\n", " daoName daoLogo organizationId \n", "0 Raid Guild RaidGuild.jpg 3a5bc696-1c33-49a8-9cee-ba8089da6a6b \n", "1 Raid Guild RaidGuild.jpg 3a5bc696-1c33-49a8-9cee-ba8089da6a6b \n", "2 Raid Guild RaidGuild.jpg 3a5bc696-1c33-49a8-9cee-ba8089da6a6b \n", "3 Raid Guild RaidGuild.jpg 3a5bc696-1c33-49a8-9cee-ba8089da6a6b \n", "4 Raid Guild RaidGuild.jpg 3a5bc696-1c33-49a8-9cee-ba8089da6a6b \n", "\n", " \\\n", " proposerId proposerName \n", "0 0x66b1de0f14a0ce971f7f248415063d44caf19398 Yalor \n", "1 0x66b1de0f14a0ce971f7f248415063d44caf19398 Yalor \n", "2 0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9 Ven Gist \n", "3 0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9 Ven Gist \n", "4 0xd26a3f686d43f2a62ba9eae2ff77e9f516d945b9 Ven Gist \n", "\n", " \\\n", " proposerAvatar \n", "0 https://ipfs.io/ipfs/QmbK3qEYJCiyjUCjGpLLsk7bi... \n", "1 https://ipfs.io/ipfs/QmbK3qEYJCiyjUCjGpLLsk7bi... \n", "2 https://ipfs.io/ipfs/QmX5zzpTqkr1Nc8WtSX5kiqaK... \n", "3 https://ipfs.io/ipfs/QmX5zzpTqkr1Nc8WtSX5kiqaK... \n", "4 https://ipfs.io/ipfs/QmX5zzpTqkr1Nc8WtSX5kiqaK... \n", "\n", " ... \\\n", " title ... \n", "0 Raid <>Dragon Quest Bounties ... \n", "1 New Member: Burrrata (@Burrrata) ... \n", "2 New Member: Felipe (@duartedao) ... \n", "3 Funding: Raid Guild Tshirt Reimbursement ... \n", "4 New Member: Lili (@lililashka) ... \n", "\n", " scottrepreneur \\\n", " organizationId \n", "0 8c21c472-1533-4e88-9119-6266e0fcb158 \n", "1 8c21c472-1533-4e88-9119-6266e0fcb158 \n", "2 8c21c472-1533-4e88-9119-6266e0fcb158 \n", "3 ba288cda-5c0e-4cea-90ca-104824d7e42b \n", "4 4c7bad27-7ae1-4a39-ad8c-6cc776ef2d1a \n", "\n", " \\\n", " proposerId proposerName \n", "0 0x865c2f85c9fea1c6ac7f53de07554d68cb92ed88 Peter 'pet3rpan' \n", "1 0xc7f459c7edcf9333d223bd1c346f46819403ca06 Sydney \n", "2 0x865c2f85c9fea1c6ac7f53de07554d68cb92ed88 Peter 'pet3rpan' \n", "3 0xced608aa29bb92185d9b6340adcbfa263dae075b Deke \n", "4 0xfb3d6b83e51a08ca89dcfe853e7ccbf5ee6ffbf4 0xfb3d...fbf4 \n", "\n", " \\\n", " proposerAvatar \n", "0 https://ipfs.io/ipfs/QmYxQz6ihvTX6JZBqANn7rzcw... \n", "1 https://ipfs.io/ipfs/QmZH5GGr5vbX2S1sRHZFsf2iZ... \n", "2 https://ipfs.io/ipfs/QmYxQz6ihvTX6JZBqANn7rzcw... \n", "3 https://ipfs.io/ipfs/QmZSdi7FdSkX8DpXRgEcyDFwC... \n", "4 None \n", "\n", " \\\n", " title \n", "0 Monthly Paladins Circle Reward \n", "1 Meta Gamma Delta ΜΓΔ \n", "2 DAO Membership Proposal #58: Jon T \n", "3 xDai DAO Migration \n", "4 Minion sends a token \n", "\n", " \\\n", " description votesCount status \n", "0 Monthly Paladins Circle Reward 2 ACCEPTED \n", "1 A buidl sorority that supports dope projects m... 4 ACCEPTED \n", "2 https://forum.metacartel.org/t/dao-membership-... 3 ACCEPTED \n", "3 xDai or bust. Transfer all funds to xDai dao. ... 7 ACCEPTED \n", "4 August Retry 1 ACCEPTED \n", "\n", " \n", " voteNativeId voteChoice \n", "0 0x0372f3696fa7dc99801f435fd6737e57818239f2-mem... 1.0 \n", "1 0x0372f3696fa7dc99801f435fd6737e57818239f2-mem... 1.0 \n", "2 0x0372f3696fa7dc99801f435fd6737e57818239f2-mem... 1.0 \n", "3 0xdec090a12f2e280b089daa225892d9efa8ed0ee8-mem... 1.0 \n", "4 0xc8e0d7fd13eb3cbc19eb293d0e00b8386cc1b6f2-mem... 1.0 \n", "\n", "[5 rows x 30 columns]" ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" } ], "source": [ "member_votes = dd.get_member_votes(pubkeys=pubkeys)\n", "member_votes.head()" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.7" } }, "nbformat": 4, "nbformat_minor": 5 }